﻿if exists (select * from sysobjects where id = object_id(N'pBUGLOGRolesAdd') and sysstat & 0xf = 4) drop procedure pBUGLOGRolesAdd 
GO

-- Creates a new record in the [dbo].[Roles] table.
CREATE PROCEDURE pBUGLOGRolesAdd
    @p_Role varchar(25),
    @p_RoleDescription varchar(250),
    @p_RoleID_out int output
AS
BEGIN
    INSERT
    INTO [dbo].[Roles]
        (
            [Role],
            [RoleDescription]
        )
    VALUES
        (
             @p_Role,
             @p_RoleDescription
        )

    SET @p_RoleID_out = SCOPE_IDENTITY()

END

